SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=1 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+houses +real +estate' IN BOOLEAN MODE)) AND iCityID IN (69874,68140,68183,68546,68002,68952,68251,69461) ORDER BY FIELD(iCityID, 69874,68140,68183,68546,68002,68952,68251,69461) ASC, p.tmPosted DESC LIMIT 24
houses real estate, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Basni
